package com.gopay.remote.fundcps.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class FundpGopayOpenAcctExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public FundpGopayOpenAcctExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andKeyIdIsNull() {
            addCriterion("KEY_ID is null");
            return (Criteria) this;
        }

        public Criteria andKeyIdIsNotNull() {
            addCriterion("KEY_ID is not null");
            return (Criteria) this;
        }

        public Criteria andKeyIdEqualTo(Long value) {
            addCriterion("KEY_ID =", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdNotEqualTo(Long value) {
            addCriterion("KEY_ID <>", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdGreaterThan(Long value) {
            addCriterion("KEY_ID >", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdGreaterThanOrEqualTo(Long value) {
            addCriterion("KEY_ID >=", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdLessThan(Long value) {
            addCriterion("KEY_ID <", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdLessThanOrEqualTo(Long value) {
            addCriterion("KEY_ID <=", value, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdIn(List<Long> values) {
            addCriterion("KEY_ID in", values, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdNotIn(List<Long> values) {
            addCriterion("KEY_ID not in", values, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdBetween(Long value1, Long value2) {
            addCriterion("KEY_ID between", value1, value2, "keyId");
            return (Criteria) this;
        }

        public Criteria andKeyIdNotBetween(Long value1, Long value2) {
            addCriterion("KEY_ID not between", value1, value2, "keyId");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNull() {
            addCriterion("CUST_ID is null");
            return (Criteria) this;
        }

        public Criteria andCustIdIsNotNull() {
            addCriterion("CUST_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCustIdEqualTo(String value) {
            addCriterion("CUST_ID =", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotEqualTo(String value) {
            addCriterion("CUST_ID <>", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThan(String value) {
            addCriterion("CUST_ID >", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdGreaterThanOrEqualTo(String value) {
            addCriterion("CUST_ID >=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThan(String value) {
            addCriterion("CUST_ID <", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLessThanOrEqualTo(String value) {
            addCriterion("CUST_ID <=", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdLike(String value) {
            addCriterion("CUST_ID like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotLike(String value) {
            addCriterion("CUST_ID not like", value, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdIn(List<String> values) {
            addCriterion("CUST_ID in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotIn(List<String> values) {
            addCriterion("CUST_ID not in", values, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdBetween(String value1, String value2) {
            addCriterion("CUST_ID between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andCustIdNotBetween(String value1, String value2) {
            addCriterion("CUST_ID not between", value1, value2, "custId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNull() {
            addCriterion("MERCHANT_ID is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNotNull() {
            addCriterion("MERCHANT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualTo(String value) {
            addCriterion("MERCHANT_ID =", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualTo(String value) {
            addCriterion("MERCHANT_ID <>", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThan(String value) {
            addCriterion("MERCHANT_ID >", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualTo(String value) {
            addCriterion("MERCHANT_ID >=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThan(String value) {
            addCriterion("MERCHANT_ID <", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualTo(String value) {
            addCriterion("MERCHANT_ID <=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLike(String value) {
            addCriterion("MERCHANT_ID like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotLike(String value) {
            addCriterion("MERCHANT_ID not like", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIn(List<String> values) {
            addCriterion("MERCHANT_ID in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotIn(List<String> values) {
            addCriterion("MERCHANT_ID not in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdBetween(String value1, String value2) {
            addCriterion("MERCHANT_ID between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotBetween(String value1, String value2) {
            addCriterion("MERCHANT_ID not between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoIsNull() {
            addCriterion("AGREEMENT_SIGN_NO is null");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoIsNotNull() {
            addCriterion("AGREEMENT_SIGN_NO is not null");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO =", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO <>", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoGreaterThan(String value) {
            addCriterion("AGREEMENT_SIGN_NO >", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoGreaterThanOrEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO >=", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoLessThan(String value) {
            addCriterion("AGREEMENT_SIGN_NO <", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoLessThanOrEqualTo(String value) {
            addCriterion("AGREEMENT_SIGN_NO <=", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoLike(String value) {
            addCriterion("AGREEMENT_SIGN_NO like", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotLike(String value) {
            addCriterion("AGREEMENT_SIGN_NO not like", value, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoIn(List<String> values) {
            addCriterion("AGREEMENT_SIGN_NO in", values, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotIn(List<String> values) {
            addCriterion("AGREEMENT_SIGN_NO not in", values, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoBetween(String value1, String value2) {
            addCriterion("AGREEMENT_SIGN_NO between", value1, value2, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAgreementSignNoNotBetween(String value1, String value2) {
            addCriterion("AGREEMENT_SIGN_NO not between", value1, value2, "agreementSignNo");
            return (Criteria) this;
        }

        public Criteria andAcctIdIsNull() {
            addCriterion("ACCT_ID is null");
            return (Criteria) this;
        }

        public Criteria andAcctIdIsNotNull() {
            addCriterion("ACCT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAcctIdEqualTo(String value) {
            addCriterion("ACCT_ID =", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdNotEqualTo(String value) {
            addCriterion("ACCT_ID <>", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdGreaterThan(String value) {
            addCriterion("ACCT_ID >", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdGreaterThanOrEqualTo(String value) {
            addCriterion("ACCT_ID >=", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdLessThan(String value) {
            addCriterion("ACCT_ID <", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdLessThanOrEqualTo(String value) {
            addCriterion("ACCT_ID <=", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdLike(String value) {
            addCriterion("ACCT_ID like", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdNotLike(String value) {
            addCriterion("ACCT_ID not like", value, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdIn(List<String> values) {
            addCriterion("ACCT_ID in", values, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdNotIn(List<String> values) {
            addCriterion("ACCT_ID not in", values, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdBetween(String value1, String value2) {
            addCriterion("ACCT_ID between", value1, value2, "acctId");
            return (Criteria) this;
        }

        public Criteria andAcctIdNotBetween(String value1, String value2) {
            addCriterion("ACCT_ID not between", value1, value2, "acctId");
            return (Criteria) this;
        }

        public Criteria andOpenStatusIsNull() {
            addCriterion("OPEN_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andOpenStatusIsNotNull() {
            addCriterion("OPEN_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOpenStatusEqualTo(String value) {
            addCriterion("OPEN_STATUS =", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusNotEqualTo(String value) {
            addCriterion("OPEN_STATUS <>", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusGreaterThan(String value) {
            addCriterion("OPEN_STATUS >", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusGreaterThanOrEqualTo(String value) {
            addCriterion("OPEN_STATUS >=", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusLessThan(String value) {
            addCriterion("OPEN_STATUS <", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusLessThanOrEqualTo(String value) {
            addCriterion("OPEN_STATUS <=", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusLike(String value) {
            addCriterion("OPEN_STATUS like", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusNotLike(String value) {
            addCriterion("OPEN_STATUS not like", value, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusIn(List<String> values) {
            addCriterion("OPEN_STATUS in", values, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusNotIn(List<String> values) {
            addCriterion("OPEN_STATUS not in", values, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusBetween(String value1, String value2) {
            addCriterion("OPEN_STATUS between", value1, value2, "openStatus");
            return (Criteria) this;
        }

        public Criteria andOpenStatusNotBetween(String value1, String value2) {
            addCriterion("OPEN_STATUS not between", value1, value2, "openStatus");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoIsNull() {
            addCriterion("APP_SHEET_SERIAL_NO is null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoIsNotNull() {
            addCriterion("APP_SHEET_SERIAL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO =", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO <>", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoGreaterThan(String value) {
            addCriterion("APP_SHEET_SERIAL_NO >", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoGreaterThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO >=", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoLessThan(String value) {
            addCriterion("APP_SHEET_SERIAL_NO <", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoLessThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIAL_NO <=", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoLike(String value) {
            addCriterion("APP_SHEET_SERIAL_NO like", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotLike(String value) {
            addCriterion("APP_SHEET_SERIAL_NO not like", value, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoIn(List<String> values) {
            addCriterion("APP_SHEET_SERIAL_NO in", values, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotIn(List<String> values) {
            addCriterion("APP_SHEET_SERIAL_NO not in", values, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIAL_NO between", value1, value2, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialNoNotBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIAL_NO not between", value1, value2, "appSheetSerialNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoIsNull() {
            addCriterion("FUND_CUST_NO is null");
            return (Criteria) this;
        }

        public Criteria andFundCustNoIsNotNull() {
            addCriterion("FUND_CUST_NO is not null");
            return (Criteria) this;
        }

        public Criteria andFundCustNoEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO =", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoNotEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO <>", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoGreaterThan(Integer value) {
            addCriterion("FUND_CUST_NO >", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoGreaterThanOrEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO >=", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoLessThan(Integer value) {
            addCriterion("FUND_CUST_NO <", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoLessThanOrEqualTo(Integer value) {
            addCriterion("FUND_CUST_NO <=", value, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoIn(List<Integer> values) {
            addCriterion("FUND_CUST_NO in", values, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoNotIn(List<Integer> values) {
            addCriterion("FUND_CUST_NO not in", values, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoBetween(Integer value1, Integer value2) {
            addCriterion("FUND_CUST_NO between", value1, value2, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andFundCustNoNotBetween(Integer value1, Integer value2) {
            addCriterion("FUND_CUST_NO not between", value1, value2, "fundCustNo");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountIsNull() {
            addCriterion("MONEY_ACCOUNT is null");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountIsNotNull() {
            addCriterion("MONEY_ACCOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountEqualTo(Long value) {
            addCriterion("MONEY_ACCOUNT =", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountNotEqualTo(Long value) {
            addCriterion("MONEY_ACCOUNT <>", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountGreaterThan(Long value) {
            addCriterion("MONEY_ACCOUNT >", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountGreaterThanOrEqualTo(Long value) {
            addCriterion("MONEY_ACCOUNT >=", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountLessThan(Long value) {
            addCriterion("MONEY_ACCOUNT <", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountLessThanOrEqualTo(Long value) {
            addCriterion("MONEY_ACCOUNT <=", value, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountIn(List<Long> values) {
            addCriterion("MONEY_ACCOUNT in", values, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountNotIn(List<Long> values) {
            addCriterion("MONEY_ACCOUNT not in", values, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountBetween(Long value1, Long value2) {
            addCriterion("MONEY_ACCOUNT between", value1, value2, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andMoneyAccountNotBetween(Long value1, Long value2) {
            addCriterion("MONEY_ACCOUNT not between", value1, value2, "moneyAccount");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdIsNull() {
            addCriterion("TA_ACCOUNT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdIsNotNull() {
            addCriterion("TA_ACCOUNT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdEqualTo(String value) {
            addCriterion("TA_ACCOUNT_ID =", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdNotEqualTo(String value) {
            addCriterion("TA_ACCOUNT_ID <>", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdGreaterThan(String value) {
            addCriterion("TA_ACCOUNT_ID >", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdGreaterThanOrEqualTo(String value) {
            addCriterion("TA_ACCOUNT_ID >=", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdLessThan(String value) {
            addCriterion("TA_ACCOUNT_ID <", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdLessThanOrEqualTo(String value) {
            addCriterion("TA_ACCOUNT_ID <=", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdLike(String value) {
            addCriterion("TA_ACCOUNT_ID like", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdNotLike(String value) {
            addCriterion("TA_ACCOUNT_ID not like", value, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdIn(List<String> values) {
            addCriterion("TA_ACCOUNT_ID in", values, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdNotIn(List<String> values) {
            addCriterion("TA_ACCOUNT_ID not in", values, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdBetween(String value1, String value2) {
            addCriterion("TA_ACCOUNT_ID between", value1, value2, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTaAccountIdNotBetween(String value1, String value2) {
            addCriterion("TA_ACCOUNT_ID not between", value1, value2, "taAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdIsNull() {
            addCriterion("TRANSACTION_ACCOUNT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdIsNotNull() {
            addCriterion("TRANSACTION_ACCOUNT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID =", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID <>", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdGreaterThan(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID >", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID >=", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdLessThan(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID <", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID <=", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdLike(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID like", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotLike(String value) {
            addCriterion("TRANSACTION_ACCOUNT_ID not like", value, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdIn(List<String> values) {
            addCriterion("TRANSACTION_ACCOUNT_ID in", values, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotIn(List<String> values) {
            addCriterion("TRANSACTION_ACCOUNT_ID not in", values, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdBetween(String value1, String value2) {
            addCriterion("TRANSACTION_ACCOUNT_ID between", value1, value2, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andTransactionAccountIdNotBetween(String value1, String value2) {
            addCriterion("TRANSACTION_ACCOUNT_ID not between", value1, value2, "transactionAccountId");
            return (Criteria) this;
        }

        public Criteria andCustFullNameIsNull() {
            addCriterion("CUST_FULL_NAME is null");
            return (Criteria) this;
        }

        public Criteria andCustFullNameIsNotNull() {
            addCriterion("CUST_FULL_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andCustFullNameEqualTo(String value) {
            addCriterion("CUST_FULL_NAME =", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameNotEqualTo(String value) {
            addCriterion("CUST_FULL_NAME <>", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameGreaterThan(String value) {
            addCriterion("CUST_FULL_NAME >", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameGreaterThanOrEqualTo(String value) {
            addCriterion("CUST_FULL_NAME >=", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameLessThan(String value) {
            addCriterion("CUST_FULL_NAME <", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameLessThanOrEqualTo(String value) {
            addCriterion("CUST_FULL_NAME <=", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameLike(String value) {
            addCriterion("CUST_FULL_NAME like", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameNotLike(String value) {
            addCriterion("CUST_FULL_NAME not like", value, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameIn(List<String> values) {
            addCriterion("CUST_FULL_NAME in", values, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameNotIn(List<String> values) {
            addCriterion("CUST_FULL_NAME not in", values, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameBetween(String value1, String value2) {
            addCriterion("CUST_FULL_NAME between", value1, value2, "custFullName");
            return (Criteria) this;
        }

        public Criteria andCustFullNameNotBetween(String value1, String value2) {
            addCriterion("CUST_FULL_NAME not between", value1, value2, "custFullName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameIsNull() {
            addCriterion("FAMILY_NAME is null");
            return (Criteria) this;
        }

        public Criteria andFamilyNameIsNotNull() {
            addCriterion("FAMILY_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andFamilyNameEqualTo(String value) {
            addCriterion("FAMILY_NAME =", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameNotEqualTo(String value) {
            addCriterion("FAMILY_NAME <>", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameGreaterThan(String value) {
            addCriterion("FAMILY_NAME >", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameGreaterThanOrEqualTo(String value) {
            addCriterion("FAMILY_NAME >=", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameLessThan(String value) {
            addCriterion("FAMILY_NAME <", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameLessThanOrEqualTo(String value) {
            addCriterion("FAMILY_NAME <=", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameLike(String value) {
            addCriterion("FAMILY_NAME like", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameNotLike(String value) {
            addCriterion("FAMILY_NAME not like", value, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameIn(List<String> values) {
            addCriterion("FAMILY_NAME in", values, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameNotIn(List<String> values) {
            addCriterion("FAMILY_NAME not in", values, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameBetween(String value1, String value2) {
            addCriterion("FAMILY_NAME between", value1, value2, "familyName");
            return (Criteria) this;
        }

        public Criteria andFamilyNameNotBetween(String value1, String value2) {
            addCriterion("FAMILY_NAME not between", value1, value2, "familyName");
            return (Criteria) this;
        }

        public Criteria andFirstNameIsNull() {
            addCriterion("FIRST_NAME is null");
            return (Criteria) this;
        }

        public Criteria andFirstNameIsNotNull() {
            addCriterion("FIRST_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andFirstNameEqualTo(String value) {
            addCriterion("FIRST_NAME =", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameNotEqualTo(String value) {
            addCriterion("FIRST_NAME <>", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameGreaterThan(String value) {
            addCriterion("FIRST_NAME >", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameGreaterThanOrEqualTo(String value) {
            addCriterion("FIRST_NAME >=", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameLessThan(String value) {
            addCriterion("FIRST_NAME <", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameLessThanOrEqualTo(String value) {
            addCriterion("FIRST_NAME <=", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameLike(String value) {
            addCriterion("FIRST_NAME like", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameNotLike(String value) {
            addCriterion("FIRST_NAME not like", value, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameIn(List<String> values) {
            addCriterion("FIRST_NAME in", values, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameNotIn(List<String> values) {
            addCriterion("FIRST_NAME not in", values, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameBetween(String value1, String value2) {
            addCriterion("FIRST_NAME between", value1, value2, "firstName");
            return (Criteria) this;
        }

        public Criteria andFirstNameNotBetween(String value1, String value2) {
            addCriterion("FIRST_NAME not between", value1, value2, "firstName");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNull() {
            addCriterion("NICKNAME is null");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNotNull() {
            addCriterion("NICKNAME is not null");
            return (Criteria) this;
        }

        public Criteria andNicknameEqualTo(String value) {
            addCriterion("NICKNAME =", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("NICKNAME <>", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("NICKNAME >", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("NICKNAME >=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThan(String value) {
            addCriterion("NICKNAME <", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("NICKNAME <=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLike(String value) {
            addCriterion("NICKNAME like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotLike(String value) {
            addCriterion("NICKNAME not like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameIn(List<String> values) {
            addCriterion("NICKNAME in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("NICKNAME not in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("NICKNAME between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("NICKNAME not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andCertTypeIsNull() {
            addCriterion("CERT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCertTypeIsNotNull() {
            addCriterion("CERT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCertTypeEqualTo(String value) {
            addCriterion("CERT_TYPE =", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotEqualTo(String value) {
            addCriterion("CERT_TYPE <>", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeGreaterThan(String value) {
            addCriterion("CERT_TYPE >", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CERT_TYPE >=", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeLessThan(String value) {
            addCriterion("CERT_TYPE <", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeLessThanOrEqualTo(String value) {
            addCriterion("CERT_TYPE <=", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeLike(String value) {
            addCriterion("CERT_TYPE like", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotLike(String value) {
            addCriterion("CERT_TYPE not like", value, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeIn(List<String> values) {
            addCriterion("CERT_TYPE in", values, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotIn(List<String> values) {
            addCriterion("CERT_TYPE not in", values, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeBetween(String value1, String value2) {
            addCriterion("CERT_TYPE between", value1, value2, "certType");
            return (Criteria) this;
        }

        public Criteria andCertTypeNotBetween(String value1, String value2) {
            addCriterion("CERT_TYPE not between", value1, value2, "certType");
            return (Criteria) this;
        }

        public Criteria andCertNoIsNull() {
            addCriterion("CERT_NO is null");
            return (Criteria) this;
        }

        public Criteria andCertNoIsNotNull() {
            addCriterion("CERT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andCertNoEqualTo(String value) {
            addCriterion("CERT_NO =", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoNotEqualTo(String value) {
            addCriterion("CERT_NO <>", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoGreaterThan(String value) {
            addCriterion("CERT_NO >", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoGreaterThanOrEqualTo(String value) {
            addCriterion("CERT_NO >=", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoLessThan(String value) {
            addCriterion("CERT_NO <", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoLessThanOrEqualTo(String value) {
            addCriterion("CERT_NO <=", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoLike(String value) {
            addCriterion("CERT_NO like", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoNotLike(String value) {
            addCriterion("CERT_NO not like", value, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoIn(List<String> values) {
            addCriterion("CERT_NO in", values, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoNotIn(List<String> values) {
            addCriterion("CERT_NO not in", values, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoBetween(String value1, String value2) {
            addCriterion("CERT_NO between", value1, value2, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertNoNotBetween(String value1, String value2) {
            addCriterion("CERT_NO not between", value1, value2, "certNo");
            return (Criteria) this;
        }

        public Criteria andCertValidateIsNull() {
            addCriterion("CERT_VALIDATE is null");
            return (Criteria) this;
        }

        public Criteria andCertValidateIsNotNull() {
            addCriterion("CERT_VALIDATE is not null");
            return (Criteria) this;
        }

        public Criteria andCertValidateEqualTo(String value) {
            addCriterion("CERT_VALIDATE =", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateNotEqualTo(String value) {
            addCriterion("CERT_VALIDATE <>", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateGreaterThan(String value) {
            addCriterion("CERT_VALIDATE >", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateGreaterThanOrEqualTo(String value) {
            addCriterion("CERT_VALIDATE >=", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateLessThan(String value) {
            addCriterion("CERT_VALIDATE <", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateLessThanOrEqualTo(String value) {
            addCriterion("CERT_VALIDATE <=", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateLike(String value) {
            addCriterion("CERT_VALIDATE like", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateNotLike(String value) {
            addCriterion("CERT_VALIDATE not like", value, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateIn(List<String> values) {
            addCriterion("CERT_VALIDATE in", values, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateNotIn(List<String> values) {
            addCriterion("CERT_VALIDATE not in", values, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateBetween(String value1, String value2) {
            addCriterion("CERT_VALIDATE between", value1, value2, "certValidate");
            return (Criteria) this;
        }

        public Criteria andCertValidateNotBetween(String value1, String value2) {
            addCriterion("CERT_VALIDATE not between", value1, value2, "certValidate");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoIsNull() {
            addCriterion("OFFICE_TEL_NO is null");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoIsNotNull() {
            addCriterion("OFFICE_TEL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoEqualTo(String value) {
            addCriterion("OFFICE_TEL_NO =", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoNotEqualTo(String value) {
            addCriterion("OFFICE_TEL_NO <>", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoGreaterThan(String value) {
            addCriterion("OFFICE_TEL_NO >", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoGreaterThanOrEqualTo(String value) {
            addCriterion("OFFICE_TEL_NO >=", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoLessThan(String value) {
            addCriterion("OFFICE_TEL_NO <", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoLessThanOrEqualTo(String value) {
            addCriterion("OFFICE_TEL_NO <=", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoLike(String value) {
            addCriterion("OFFICE_TEL_NO like", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoNotLike(String value) {
            addCriterion("OFFICE_TEL_NO not like", value, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoIn(List<String> values) {
            addCriterion("OFFICE_TEL_NO in", values, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoNotIn(List<String> values) {
            addCriterion("OFFICE_TEL_NO not in", values, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoBetween(String value1, String value2) {
            addCriterion("OFFICE_TEL_NO between", value1, value2, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andOfficeTelNoNotBetween(String value1, String value2) {
            addCriterion("OFFICE_TEL_NO not between", value1, value2, "officeTelNo");
            return (Criteria) this;
        }

        public Criteria andTelNoIsNull() {
            addCriterion("TEL_NO is null");
            return (Criteria) this;
        }

        public Criteria andTelNoIsNotNull() {
            addCriterion("TEL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andTelNoEqualTo(String value) {
            addCriterion("TEL_NO =", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotEqualTo(String value) {
            addCriterion("TEL_NO <>", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoGreaterThan(String value) {
            addCriterion("TEL_NO >", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoGreaterThanOrEqualTo(String value) {
            addCriterion("TEL_NO >=", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoLessThan(String value) {
            addCriterion("TEL_NO <", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoLessThanOrEqualTo(String value) {
            addCriterion("TEL_NO <=", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoLike(String value) {
            addCriterion("TEL_NO like", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotLike(String value) {
            addCriterion("TEL_NO not like", value, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoIn(List<String> values) {
            addCriterion("TEL_NO in", values, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotIn(List<String> values) {
            addCriterion("TEL_NO not in", values, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoBetween(String value1, String value2) {
            addCriterion("TEL_NO between", value1, value2, "telNo");
            return (Criteria) this;
        }

        public Criteria andTelNoNotBetween(String value1, String value2) {
            addCriterion("TEL_NO not between", value1, value2, "telNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoIsNull() {
            addCriterion("MOBILE_NO is null");
            return (Criteria) this;
        }

        public Criteria andMobileNoIsNotNull() {
            addCriterion("MOBILE_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMobileNoEqualTo(String value) {
            addCriterion("MOBILE_NO =", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoNotEqualTo(String value) {
            addCriterion("MOBILE_NO <>", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoGreaterThan(String value) {
            addCriterion("MOBILE_NO >", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE_NO >=", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoLessThan(String value) {
            addCriterion("MOBILE_NO <", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoLessThanOrEqualTo(String value) {
            addCriterion("MOBILE_NO <=", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoLike(String value) {
            addCriterion("MOBILE_NO like", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoNotLike(String value) {
            addCriterion("MOBILE_NO not like", value, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoIn(List<String> values) {
            addCriterion("MOBILE_NO in", values, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoNotIn(List<String> values) {
            addCriterion("MOBILE_NO not in", values, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoBetween(String value1, String value2) {
            addCriterion("MOBILE_NO between", value1, value2, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andMobileNoNotBetween(String value1, String value2) {
            addCriterion("MOBILE_NO not between", value1, value2, "mobileNo");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("EMAIL is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("EMAIL is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("EMAIL =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("EMAIL <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("EMAIL >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("EMAIL >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("EMAIL <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("EMAIL <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("EMAIL like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("EMAIL not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("EMAIL in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("EMAIL not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("EMAIL between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("EMAIL not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andMinorFlagIsNull() {
            addCriterion("MINOR_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andMinorFlagIsNotNull() {
            addCriterion("MINOR_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andMinorFlagEqualTo(String value) {
            addCriterion("MINOR_FLAG =", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagNotEqualTo(String value) {
            addCriterion("MINOR_FLAG <>", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagGreaterThan(String value) {
            addCriterion("MINOR_FLAG >", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagGreaterThanOrEqualTo(String value) {
            addCriterion("MINOR_FLAG >=", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagLessThan(String value) {
            addCriterion("MINOR_FLAG <", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagLessThanOrEqualTo(String value) {
            addCriterion("MINOR_FLAG <=", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagLike(String value) {
            addCriterion("MINOR_FLAG like", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagNotLike(String value) {
            addCriterion("MINOR_FLAG not like", value, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagIn(List<String> values) {
            addCriterion("MINOR_FLAG in", values, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagNotIn(List<String> values) {
            addCriterion("MINOR_FLAG not in", values, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagBetween(String value1, String value2) {
            addCriterion("MINOR_FLAG between", value1, value2, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorFlagNotBetween(String value1, String value2) {
            addCriterion("MINOR_FLAG not between", value1, value2, "minorFlag");
            return (Criteria) this;
        }

        public Criteria andMinorIdIsNull() {
            addCriterion("MINOR_ID is null");
            return (Criteria) this;
        }

        public Criteria andMinorIdIsNotNull() {
            addCriterion("MINOR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMinorIdEqualTo(String value) {
            addCriterion("MINOR_ID =", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdNotEqualTo(String value) {
            addCriterion("MINOR_ID <>", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdGreaterThan(String value) {
            addCriterion("MINOR_ID >", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdGreaterThanOrEqualTo(String value) {
            addCriterion("MINOR_ID >=", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdLessThan(String value) {
            addCriterion("MINOR_ID <", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdLessThanOrEqualTo(String value) {
            addCriterion("MINOR_ID <=", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdLike(String value) {
            addCriterion("MINOR_ID like", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdNotLike(String value) {
            addCriterion("MINOR_ID not like", value, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdIn(List<String> values) {
            addCriterion("MINOR_ID in", values, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdNotIn(List<String> values) {
            addCriterion("MINOR_ID not in", values, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdBetween(String value1, String value2) {
            addCriterion("MINOR_ID between", value1, value2, "minorId");
            return (Criteria) this;
        }

        public Criteria andMinorIdNotBetween(String value1, String value2) {
            addCriterion("MINOR_ID not between", value1, value2, "minorId");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNull() {
            addCriterion("POSTCODE is null");
            return (Criteria) this;
        }

        public Criteria andPostcodeIsNotNull() {
            addCriterion("POSTCODE is not null");
            return (Criteria) this;
        }

        public Criteria andPostcodeEqualTo(String value) {
            addCriterion("POSTCODE =", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotEqualTo(String value) {
            addCriterion("POSTCODE <>", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThan(String value) {
            addCriterion("POSTCODE >", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeGreaterThanOrEqualTo(String value) {
            addCriterion("POSTCODE >=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThan(String value) {
            addCriterion("POSTCODE <", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLessThanOrEqualTo(String value) {
            addCriterion("POSTCODE <=", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeLike(String value) {
            addCriterion("POSTCODE like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotLike(String value) {
            addCriterion("POSTCODE not like", value, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeIn(List<String> values) {
            addCriterion("POSTCODE in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotIn(List<String> values) {
            addCriterion("POSTCODE not in", values, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeBetween(String value1, String value2) {
            addCriterion("POSTCODE between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andPostcodeNotBetween(String value1, String value2) {
            addCriterion("POSTCODE not between", value1, value2, "postcode");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("ADDRESS =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("ADDRESS <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("ADDRESS >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("ADDRESS >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("ADDRESS <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("ADDRESS <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("ADDRESS like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("ADDRESS not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("ADDRESS in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("ADDRESS not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("ADDRESS between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("ADDRESS not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("FAX is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("FAX is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("FAX =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("FAX <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("FAX >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("FAX >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("FAX <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("FAX <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("FAX like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("FAX not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("FAX in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("FAX not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("FAX between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("FAX not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andCountryIsNull() {
            addCriterion("COUNTRY is null");
            return (Criteria) this;
        }

        public Criteria andCountryIsNotNull() {
            addCriterion("COUNTRY is not null");
            return (Criteria) this;
        }

        public Criteria andCountryEqualTo(String value) {
            addCriterion("COUNTRY =", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotEqualTo(String value) {
            addCriterion("COUNTRY <>", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThan(String value) {
            addCriterion("COUNTRY >", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryGreaterThanOrEqualTo(String value) {
            addCriterion("COUNTRY >=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThan(String value) {
            addCriterion("COUNTRY <", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLessThanOrEqualTo(String value) {
            addCriterion("COUNTRY <=", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryLike(String value) {
            addCriterion("COUNTRY like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotLike(String value) {
            addCriterion("COUNTRY not like", value, "country");
            return (Criteria) this;
        }

        public Criteria andCountryIn(List<String> values) {
            addCriterion("COUNTRY in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotIn(List<String> values) {
            addCriterion("COUNTRY not in", values, "country");
            return (Criteria) this;
        }

        public Criteria andCountryBetween(String value1, String value2) {
            addCriterion("COUNTRY between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andCountryNotBetween(String value1, String value2) {
            addCriterion("COUNTRY not between", value1, value2, "country");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("SEX is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("SEX is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(String value) {
            addCriterion("SEX =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(String value) {
            addCriterion("SEX <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(String value) {
            addCriterion("SEX >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("SEX >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(String value) {
            addCriterion("SEX <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(String value) {
            addCriterion("SEX <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(String value) {
            addCriterion("SEX like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(String value) {
            addCriterion("SEX not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<String> values) {
            addCriterion("SEX in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<String> values) {
            addCriterion("SEX not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(String value1, String value2) {
            addCriterion("SEX between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(String value1, String value2) {
            addCriterion("SEX not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNull() {
            addCriterion("BIRTHDAY is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNotNull() {
            addCriterion("BIRTHDAY is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayEqualTo(String value) {
            addCriterion("BIRTHDAY =", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotEqualTo(String value) {
            addCriterion("BIRTHDAY <>", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThan(String value) {
            addCriterion("BIRTHDAY >", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThanOrEqualTo(String value) {
            addCriterion("BIRTHDAY >=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThan(String value) {
            addCriterion("BIRTHDAY <", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThanOrEqualTo(String value) {
            addCriterion("BIRTHDAY <=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLike(String value) {
            addCriterion("BIRTHDAY like", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotLike(String value) {
            addCriterion("BIRTHDAY not like", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayIn(List<String> values) {
            addCriterion("BIRTHDAY in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotIn(List<String> values) {
            addCriterion("BIRTHDAY not in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayBetween(String value1, String value2) {
            addCriterion("BIRTHDAY between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotBetween(String value1, String value2) {
            addCriterion("BIRTHDAY not between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeIsNull() {
            addCriterion("INVESTOR_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeIsNotNull() {
            addCriterion("INVESTOR_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeEqualTo(String value) {
            addCriterion("INVESTOR_TYPE =", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeNotEqualTo(String value) {
            addCriterion("INVESTOR_TYPE <>", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeGreaterThan(String value) {
            addCriterion("INVESTOR_TYPE >", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeGreaterThanOrEqualTo(String value) {
            addCriterion("INVESTOR_TYPE >=", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeLessThan(String value) {
            addCriterion("INVESTOR_TYPE <", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeLessThanOrEqualTo(String value) {
            addCriterion("INVESTOR_TYPE <=", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeLike(String value) {
            addCriterion("INVESTOR_TYPE like", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeNotLike(String value) {
            addCriterion("INVESTOR_TYPE not like", value, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeIn(List<String> values) {
            addCriterion("INVESTOR_TYPE in", values, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeNotIn(List<String> values) {
            addCriterion("INVESTOR_TYPE not in", values, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeBetween(String value1, String value2) {
            addCriterion("INVESTOR_TYPE between", value1, value2, "investorType");
            return (Criteria) this;
        }

        public Criteria andInvestorTypeNotBetween(String value1, String value2) {
            addCriterion("INVESTOR_TYPE not between", value1, value2, "investorType");
            return (Criteria) this;
        }

        public Criteria andEducationLevelIsNull() {
            addCriterion("EDUCATION_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andEducationLevelIsNotNull() {
            addCriterion("EDUCATION_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andEducationLevelEqualTo(String value) {
            addCriterion("EDUCATION_LEVEL =", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelNotEqualTo(String value) {
            addCriterion("EDUCATION_LEVEL <>", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelGreaterThan(String value) {
            addCriterion("EDUCATION_LEVEL >", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelGreaterThanOrEqualTo(String value) {
            addCriterion("EDUCATION_LEVEL >=", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelLessThan(String value) {
            addCriterion("EDUCATION_LEVEL <", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelLessThanOrEqualTo(String value) {
            addCriterion("EDUCATION_LEVEL <=", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelLike(String value) {
            addCriterion("EDUCATION_LEVEL like", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelNotLike(String value) {
            addCriterion("EDUCATION_LEVEL not like", value, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelIn(List<String> values) {
            addCriterion("EDUCATION_LEVEL in", values, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelNotIn(List<String> values) {
            addCriterion("EDUCATION_LEVEL not in", values, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelBetween(String value1, String value2) {
            addCriterion("EDUCATION_LEVEL between", value1, value2, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andEducationLevelNotBetween(String value1, String value2) {
            addCriterion("EDUCATION_LEVEL not between", value1, value2, "educationLevel");
            return (Criteria) this;
        }

        public Criteria andVocationCodeIsNull() {
            addCriterion("VOCATION_CODE is null");
            return (Criteria) this;
        }

        public Criteria andVocationCodeIsNotNull() {
            addCriterion("VOCATION_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andVocationCodeEqualTo(String value) {
            addCriterion("VOCATION_CODE =", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeNotEqualTo(String value) {
            addCriterion("VOCATION_CODE <>", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeGreaterThan(String value) {
            addCriterion("VOCATION_CODE >", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeGreaterThanOrEqualTo(String value) {
            addCriterion("VOCATION_CODE >=", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeLessThan(String value) {
            addCriterion("VOCATION_CODE <", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeLessThanOrEqualTo(String value) {
            addCriterion("VOCATION_CODE <=", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeLike(String value) {
            addCriterion("VOCATION_CODE like", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeNotLike(String value) {
            addCriterion("VOCATION_CODE not like", value, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeIn(List<String> values) {
            addCriterion("VOCATION_CODE in", values, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeNotIn(List<String> values) {
            addCriterion("VOCATION_CODE not in", values, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeBetween(String value1, String value2) {
            addCriterion("VOCATION_CODE between", value1, value2, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andVocationCodeNotBetween(String value1, String value2) {
            addCriterion("VOCATION_CODE not between", value1, value2, "vocationCode");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeIsNull() {
            addCriterion("ANNUAL_INCOME is null");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeIsNotNull() {
            addCriterion("ANNUAL_INCOME is not null");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeEqualTo(String value) {
            addCriterion("ANNUAL_INCOME =", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeNotEqualTo(String value) {
            addCriterion("ANNUAL_INCOME <>", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeGreaterThan(String value) {
            addCriterion("ANNUAL_INCOME >", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeGreaterThanOrEqualTo(String value) {
            addCriterion("ANNUAL_INCOME >=", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeLessThan(String value) {
            addCriterion("ANNUAL_INCOME <", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeLessThanOrEqualTo(String value) {
            addCriterion("ANNUAL_INCOME <=", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeLike(String value) {
            addCriterion("ANNUAL_INCOME like", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeNotLike(String value) {
            addCriterion("ANNUAL_INCOME not like", value, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeIn(List<String> values) {
            addCriterion("ANNUAL_INCOME in", values, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeNotIn(List<String> values) {
            addCriterion("ANNUAL_INCOME not in", values, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeBetween(String value1, String value2) {
            addCriterion("ANNUAL_INCOME between", value1, value2, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andAnnualIncomeNotBetween(String value1, String value2) {
            addCriterion("ANNUAL_INCOME not between", value1, value2, "annualIncome");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdIsNull() {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID is null");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdIsNotNull() {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdEqualTo(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID =", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdNotEqualTo(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID <>", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdGreaterThan(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID >", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdGreaterThanOrEqualTo(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID >=", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdLessThan(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID <", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdLessThanOrEqualTo(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID <=", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdLike(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID like", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdNotLike(String value) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID not like", value, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdIn(List<String> values) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID in", values, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdNotIn(List<String> values) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID not in", values, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdBetween(String value1, String value2) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID between", value1, value2, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andSzSecuritiesAccountIdNotBetween(String value1, String value2) {
            addCriterion("SZ_SECURITIES_ACCOUNT_ID not between", value1, value2, "szSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdIsNull() {
            addCriterion("SH_SECURITIES_ACCOUNT_ID is null");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdIsNotNull() {
            addCriterion("SH_SECURITIES_ACCOUNT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdEqualTo(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID =", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdNotEqualTo(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID <>", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdGreaterThan(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID >", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdGreaterThanOrEqualTo(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID >=", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdLessThan(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID <", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdLessThanOrEqualTo(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID <=", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdLike(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID like", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdNotLike(String value) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID not like", value, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdIn(List<String> values) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID in", values, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdNotIn(List<String> values) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID not in", values, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdBetween(String value1, String value2) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID between", value1, value2, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andShSecuritiesAccountIdNotBetween(String value1, String value2) {
            addCriterion("SH_SECURITIES_ACCOUNT_ID not between", value1, value2, "shSecuritiesAccountId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdIsNull() {
            addCriterion("CUST_MANAGER_ID is null");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdIsNotNull() {
            addCriterion("CUST_MANAGER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdEqualTo(String value) {
            addCriterion("CUST_MANAGER_ID =", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdNotEqualTo(String value) {
            addCriterion("CUST_MANAGER_ID <>", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdGreaterThan(String value) {
            addCriterion("CUST_MANAGER_ID >", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdGreaterThanOrEqualTo(String value) {
            addCriterion("CUST_MANAGER_ID >=", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdLessThan(String value) {
            addCriterion("CUST_MANAGER_ID <", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdLessThanOrEqualTo(String value) {
            addCriterion("CUST_MANAGER_ID <=", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdLike(String value) {
            addCriterion("CUST_MANAGER_ID like", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdNotLike(String value) {
            addCriterion("CUST_MANAGER_ID not like", value, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdIn(List<String> values) {
            addCriterion("CUST_MANAGER_ID in", values, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdNotIn(List<String> values) {
            addCriterion("CUST_MANAGER_ID not in", values, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdBetween(String value1, String value2) {
            addCriterion("CUST_MANAGER_ID between", value1, value2, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andCustManagerIdNotBetween(String value1, String value2) {
            addCriterion("CUST_MANAGER_ID not between", value1, value2, "custManagerId");
            return (Criteria) this;
        }

        public Criteria andReferralIsNull() {
            addCriterion("REFERRAL is null");
            return (Criteria) this;
        }

        public Criteria andReferralIsNotNull() {
            addCriterion("REFERRAL is not null");
            return (Criteria) this;
        }

        public Criteria andReferralEqualTo(String value) {
            addCriterion("REFERRAL =", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralNotEqualTo(String value) {
            addCriterion("REFERRAL <>", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralGreaterThan(String value) {
            addCriterion("REFERRAL >", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL >=", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralLessThan(String value) {
            addCriterion("REFERRAL <", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL <=", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralLike(String value) {
            addCriterion("REFERRAL like", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralNotLike(String value) {
            addCriterion("REFERRAL not like", value, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralIn(List<String> values) {
            addCriterion("REFERRAL in", values, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralNotIn(List<String> values) {
            addCriterion("REFERRAL not in", values, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralBetween(String value1, String value2) {
            addCriterion("REFERRAL between", value1, value2, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralNotBetween(String value1, String value2) {
            addCriterion("REFERRAL not between", value1, value2, "referral");
            return (Criteria) this;
        }

        public Criteria andReferralMobileIsNull() {
            addCriterion("REFERRAL_MOBILE is null");
            return (Criteria) this;
        }

        public Criteria andReferralMobileIsNotNull() {
            addCriterion("REFERRAL_MOBILE is not null");
            return (Criteria) this;
        }

        public Criteria andReferralMobileEqualTo(String value) {
            addCriterion("REFERRAL_MOBILE =", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileNotEqualTo(String value) {
            addCriterion("REFERRAL_MOBILE <>", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileGreaterThan(String value) {
            addCriterion("REFERRAL_MOBILE >", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL_MOBILE >=", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileLessThan(String value) {
            addCriterion("REFERRAL_MOBILE <", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL_MOBILE <=", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileLike(String value) {
            addCriterion("REFERRAL_MOBILE like", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileNotLike(String value) {
            addCriterion("REFERRAL_MOBILE not like", value, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileIn(List<String> values) {
            addCriterion("REFERRAL_MOBILE in", values, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileNotIn(List<String> values) {
            addCriterion("REFERRAL_MOBILE not in", values, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileBetween(String value1, String value2) {
            addCriterion("REFERRAL_MOBILE between", value1, value2, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralMobileNotBetween(String value1, String value2) {
            addCriterion("REFERRAL_MOBILE not between", value1, value2, "referralMobile");
            return (Criteria) this;
        }

        public Criteria andReferralOrgIsNull() {
            addCriterion("REFERRAL_ORG is null");
            return (Criteria) this;
        }

        public Criteria andReferralOrgIsNotNull() {
            addCriterion("REFERRAL_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andReferralOrgEqualTo(String value) {
            addCriterion("REFERRAL_ORG =", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgNotEqualTo(String value) {
            addCriterion("REFERRAL_ORG <>", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgGreaterThan(String value) {
            addCriterion("REFERRAL_ORG >", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL_ORG >=", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgLessThan(String value) {
            addCriterion("REFERRAL_ORG <", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL_ORG <=", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgLike(String value) {
            addCriterion("REFERRAL_ORG like", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgNotLike(String value) {
            addCriterion("REFERRAL_ORG not like", value, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgIn(List<String> values) {
            addCriterion("REFERRAL_ORG in", values, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgNotIn(List<String> values) {
            addCriterion("REFERRAL_ORG not in", values, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgBetween(String value1, String value2) {
            addCriterion("REFERRAL_ORG between", value1, value2, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralOrgNotBetween(String value1, String value2) {
            addCriterion("REFERRAL_ORG not between", value1, value2, "referralOrg");
            return (Criteria) this;
        }

        public Criteria andReferralIdIsNull() {
            addCriterion("REFERRAL_ID is null");
            return (Criteria) this;
        }

        public Criteria andReferralIdIsNotNull() {
            addCriterion("REFERRAL_ID is not null");
            return (Criteria) this;
        }

        public Criteria andReferralIdEqualTo(String value) {
            addCriterion("REFERRAL_ID =", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotEqualTo(String value) {
            addCriterion("REFERRAL_ID <>", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdGreaterThan(String value) {
            addCriterion("REFERRAL_ID >", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL_ID >=", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdLessThan(String value) {
            addCriterion("REFERRAL_ID <", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL_ID <=", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdLike(String value) {
            addCriterion("REFERRAL_ID like", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotLike(String value) {
            addCriterion("REFERRAL_ID not like", value, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdIn(List<String> values) {
            addCriterion("REFERRAL_ID in", values, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotIn(List<String> values) {
            addCriterion("REFERRAL_ID not in", values, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdBetween(String value1, String value2) {
            addCriterion("REFERRAL_ID between", value1, value2, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralIdNotBetween(String value1, String value2) {
            addCriterion("REFERRAL_ID not between", value1, value2, "referralId");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameIsNull() {
            addCriterion("REFERRAL_PROVINCE_NAME is null");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameIsNotNull() {
            addCriterion("REFERRAL_PROVINCE_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameEqualTo(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME =", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameNotEqualTo(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME <>", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameGreaterThan(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME >", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME >=", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameLessThan(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME <", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME <=", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameLike(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME like", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameNotLike(String value) {
            addCriterion("REFERRAL_PROVINCE_NAME not like", value, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameIn(List<String> values) {
            addCriterion("REFERRAL_PROVINCE_NAME in", values, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameNotIn(List<String> values) {
            addCriterion("REFERRAL_PROVINCE_NAME not in", values, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameBetween(String value1, String value2) {
            addCriterion("REFERRAL_PROVINCE_NAME between", value1, value2, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralProvinceNameNotBetween(String value1, String value2) {
            addCriterion("REFERRAL_PROVINCE_NAME not between", value1, value2, "referralProvinceName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameIsNull() {
            addCriterion("REFERRAL_CITY_NAME is null");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameIsNotNull() {
            addCriterion("REFERRAL_CITY_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameEqualTo(String value) {
            addCriterion("REFERRAL_CITY_NAME =", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameNotEqualTo(String value) {
            addCriterion("REFERRAL_CITY_NAME <>", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameGreaterThan(String value) {
            addCriterion("REFERRAL_CITY_NAME >", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("REFERRAL_CITY_NAME >=", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameLessThan(String value) {
            addCriterion("REFERRAL_CITY_NAME <", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameLessThanOrEqualTo(String value) {
            addCriterion("REFERRAL_CITY_NAME <=", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameLike(String value) {
            addCriterion("REFERRAL_CITY_NAME like", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameNotLike(String value) {
            addCriterion("REFERRAL_CITY_NAME not like", value, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameIn(List<String> values) {
            addCriterion("REFERRAL_CITY_NAME in", values, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameNotIn(List<String> values) {
            addCriterion("REFERRAL_CITY_NAME not in", values, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameBetween(String value1, String value2) {
            addCriterion("REFERRAL_CITY_NAME between", value1, value2, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andReferralCityNameNotBetween(String value1, String value2) {
            addCriterion("REFERRAL_CITY_NAME not between", value1, value2, "referralCityName");
            return (Criteria) this;
        }

        public Criteria andDeliverWayIsNull() {
            addCriterion("DELIVER_WAY is null");
            return (Criteria) this;
        }

        public Criteria andDeliverWayIsNotNull() {
            addCriterion("DELIVER_WAY is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverWayEqualTo(String value) {
            addCriterion("DELIVER_WAY =", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayNotEqualTo(String value) {
            addCriterion("DELIVER_WAY <>", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayGreaterThan(String value) {
            addCriterion("DELIVER_WAY >", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayGreaterThanOrEqualTo(String value) {
            addCriterion("DELIVER_WAY >=", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayLessThan(String value) {
            addCriterion("DELIVER_WAY <", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayLessThanOrEqualTo(String value) {
            addCriterion("DELIVER_WAY <=", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayLike(String value) {
            addCriterion("DELIVER_WAY like", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayNotLike(String value) {
            addCriterion("DELIVER_WAY not like", value, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayIn(List<String> values) {
            addCriterion("DELIVER_WAY in", values, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayNotIn(List<String> values) {
            addCriterion("DELIVER_WAY not in", values, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayBetween(String value1, String value2) {
            addCriterion("DELIVER_WAY between", value1, value2, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverWayNotBetween(String value1, String value2) {
            addCriterion("DELIVER_WAY not between", value1, value2, "deliverWay");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeIsNull() {
            addCriterion("DELIVER_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeIsNotNull() {
            addCriterion("DELIVER_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeEqualTo(String value) {
            addCriterion("DELIVER_TYPE =", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeNotEqualTo(String value) {
            addCriterion("DELIVER_TYPE <>", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeGreaterThan(String value) {
            addCriterion("DELIVER_TYPE >", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeGreaterThanOrEqualTo(String value) {
            addCriterion("DELIVER_TYPE >=", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeLessThan(String value) {
            addCriterion("DELIVER_TYPE <", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeLessThanOrEqualTo(String value) {
            addCriterion("DELIVER_TYPE <=", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeLike(String value) {
            addCriterion("DELIVER_TYPE like", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeNotLike(String value) {
            addCriterion("DELIVER_TYPE not like", value, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeIn(List<String> values) {
            addCriterion("DELIVER_TYPE in", values, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeNotIn(List<String> values) {
            addCriterion("DELIVER_TYPE not in", values, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeBetween(String value1, String value2) {
            addCriterion("DELIVER_TYPE between", value1, value2, "deliverType");
            return (Criteria) this;
        }

        public Criteria andDeliverTypeNotBetween(String value1, String value2) {
            addCriterion("DELIVER_TYPE not between", value1, value2, "deliverType");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNull() {
            addCriterion("CHANNEL_ID is null");
            return (Criteria) this;
        }

        public Criteria andChannelIdIsNotNull() {
            addCriterion("CHANNEL_ID is not null");
            return (Criteria) this;
        }

        public Criteria andChannelIdEqualTo(String value) {
            addCriterion("CHANNEL_ID =", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotEqualTo(String value) {
            addCriterion("CHANNEL_ID <>", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThan(String value) {
            addCriterion("CHANNEL_ID >", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL_ID >=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThan(String value) {
            addCriterion("CHANNEL_ID <", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL_ID <=", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdLike(String value) {
            addCriterion("CHANNEL_ID like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotLike(String value) {
            addCriterion("CHANNEL_ID not like", value, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdIn(List<String> values) {
            addCriterion("CHANNEL_ID in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotIn(List<String> values) {
            addCriterion("CHANNEL_ID not in", values, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdBetween(String value1, String value2) {
            addCriterion("CHANNEL_ID between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andChannelIdNotBetween(String value1, String value2) {
            addCriterion("CHANNEL_ID not between", value1, value2, "channelId");
            return (Criteria) this;
        }

        public Criteria andDepositProvIsNull() {
            addCriterion("DEPOSIT_PROV is null");
            return (Criteria) this;
        }

        public Criteria andDepositProvIsNotNull() {
            addCriterion("DEPOSIT_PROV is not null");
            return (Criteria) this;
        }

        public Criteria andDepositProvEqualTo(String value) {
            addCriterion("DEPOSIT_PROV =", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotEqualTo(String value) {
            addCriterion("DEPOSIT_PROV <>", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvGreaterThan(String value) {
            addCriterion("DEPOSIT_PROV >", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_PROV >=", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvLessThan(String value) {
            addCriterion("DEPOSIT_PROV <", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_PROV <=", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvLike(String value) {
            addCriterion("DEPOSIT_PROV like", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotLike(String value) {
            addCriterion("DEPOSIT_PROV not like", value, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvIn(List<String> values) {
            addCriterion("DEPOSIT_PROV in", values, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotIn(List<String> values) {
            addCriterion("DEPOSIT_PROV not in", values, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvBetween(String value1, String value2) {
            addCriterion("DEPOSIT_PROV between", value1, value2, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositProvNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_PROV not between", value1, value2, "depositProv");
            return (Criteria) this;
        }

        public Criteria andDepositCityIsNull() {
            addCriterion("DEPOSIT_CITY is null");
            return (Criteria) this;
        }

        public Criteria andDepositCityIsNotNull() {
            addCriterion("DEPOSIT_CITY is not null");
            return (Criteria) this;
        }

        public Criteria andDepositCityEqualTo(String value) {
            addCriterion("DEPOSIT_CITY =", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotEqualTo(String value) {
            addCriterion("DEPOSIT_CITY <>", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityGreaterThan(String value) {
            addCriterion("DEPOSIT_CITY >", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_CITY >=", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityLessThan(String value) {
            addCriterion("DEPOSIT_CITY <", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_CITY <=", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityLike(String value) {
            addCriterion("DEPOSIT_CITY like", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotLike(String value) {
            addCriterion("DEPOSIT_CITY not like", value, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityIn(List<String> values) {
            addCriterion("DEPOSIT_CITY in", values, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotIn(List<String> values) {
            addCriterion("DEPOSIT_CITY not in", values, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityBetween(String value1, String value2) {
            addCriterion("DEPOSIT_CITY between", value1, value2, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositCityNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_CITY not between", value1, value2, "depositCity");
            return (Criteria) this;
        }

        public Criteria andDepositNameIsNull() {
            addCriterion("DEPOSIT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDepositNameIsNotNull() {
            addCriterion("DEPOSIT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDepositNameEqualTo(String value) {
            addCriterion("DEPOSIT_NAME =", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotEqualTo(String value) {
            addCriterion("DEPOSIT_NAME <>", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameGreaterThan(String value) {
            addCriterion("DEPOSIT_NAME >", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_NAME >=", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameLessThan(String value) {
            addCriterion("DEPOSIT_NAME <", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_NAME <=", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameLike(String value) {
            addCriterion("DEPOSIT_NAME like", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotLike(String value) {
            addCriterion("DEPOSIT_NAME not like", value, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameIn(List<String> values) {
            addCriterion("DEPOSIT_NAME in", values, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotIn(List<String> values) {
            addCriterion("DEPOSIT_NAME not in", values, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameBetween(String value1, String value2) {
            addCriterion("DEPOSIT_NAME between", value1, value2, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositNameNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_NAME not between", value1, value2, "depositName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameIsNull() {
            addCriterion("DEPOSIT_ACCT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameIsNotNull() {
            addCriterion("DEPOSIT_ACCT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME =", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME <>", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameGreaterThan(String value) {
            addCriterion("DEPOSIT_ACCT_NAME >", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameGreaterThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME >=", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameLessThan(String value) {
            addCriterion("DEPOSIT_ACCT_NAME <", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameLessThanOrEqualTo(String value) {
            addCriterion("DEPOSIT_ACCT_NAME <=", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameLike(String value) {
            addCriterion("DEPOSIT_ACCT_NAME like", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotLike(String value) {
            addCriterion("DEPOSIT_ACCT_NAME not like", value, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameIn(List<String> values) {
            addCriterion("DEPOSIT_ACCT_NAME in", values, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotIn(List<String> values) {
            addCriterion("DEPOSIT_ACCT_NAME not in", values, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameBetween(String value1, String value2) {
            addCriterion("DEPOSIT_ACCT_NAME between", value1, value2, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andDepositAcctNameNotBetween(String value1, String value2) {
            addCriterion("DEPOSIT_ACCT_NAME not between", value1, value2, "depositAcctName");
            return (Criteria) this;
        }

        public Criteria andIsMainBackIsNull() {
            addCriterion("IS_MAIN_BACK is null");
            return (Criteria) this;
        }

        public Criteria andIsMainBackIsNotNull() {
            addCriterion("IS_MAIN_BACK is not null");
            return (Criteria) this;
        }

        public Criteria andIsMainBackEqualTo(String value) {
            addCriterion("IS_MAIN_BACK =", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackNotEqualTo(String value) {
            addCriterion("IS_MAIN_BACK <>", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackGreaterThan(String value) {
            addCriterion("IS_MAIN_BACK >", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackGreaterThanOrEqualTo(String value) {
            addCriterion("IS_MAIN_BACK >=", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackLessThan(String value) {
            addCriterion("IS_MAIN_BACK <", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackLessThanOrEqualTo(String value) {
            addCriterion("IS_MAIN_BACK <=", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackLike(String value) {
            addCriterion("IS_MAIN_BACK like", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackNotLike(String value) {
            addCriterion("IS_MAIN_BACK not like", value, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackIn(List<String> values) {
            addCriterion("IS_MAIN_BACK in", values, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackNotIn(List<String> values) {
            addCriterion("IS_MAIN_BACK not in", values, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackBetween(String value1, String value2) {
            addCriterion("IS_MAIN_BACK between", value1, value2, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainBackNotBetween(String value1, String value2) {
            addCriterion("IS_MAIN_BACK not between", value1, value2, "isMainBack");
            return (Criteria) this;
        }

        public Criteria andIsMainPayIsNull() {
            addCriterion("IS_MAIN_PAY is null");
            return (Criteria) this;
        }

        public Criteria andIsMainPayIsNotNull() {
            addCriterion("IS_MAIN_PAY is not null");
            return (Criteria) this;
        }

        public Criteria andIsMainPayEqualTo(String value) {
            addCriterion("IS_MAIN_PAY =", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayNotEqualTo(String value) {
            addCriterion("IS_MAIN_PAY <>", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayGreaterThan(String value) {
            addCriterion("IS_MAIN_PAY >", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayGreaterThanOrEqualTo(String value) {
            addCriterion("IS_MAIN_PAY >=", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayLessThan(String value) {
            addCriterion("IS_MAIN_PAY <", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayLessThanOrEqualTo(String value) {
            addCriterion("IS_MAIN_PAY <=", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayLike(String value) {
            addCriterion("IS_MAIN_PAY like", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayNotLike(String value) {
            addCriterion("IS_MAIN_PAY not like", value, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayIn(List<String> values) {
            addCriterion("IS_MAIN_PAY in", values, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayNotIn(List<String> values) {
            addCriterion("IS_MAIN_PAY not in", values, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayBetween(String value1, String value2) {
            addCriterion("IS_MAIN_PAY between", value1, value2, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andIsMainPayNotBetween(String value1, String value2) {
            addCriterion("IS_MAIN_PAY not between", value1, value2, "isMainPay");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagIsNull() {
            addCriterion("AUTHENTICATE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagIsNotNull() {
            addCriterion("AUTHENTICATE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG =", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG <>", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagGreaterThan(String value) {
            addCriterion("AUTHENTICATE_FLAG >", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagGreaterThanOrEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG >=", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagLessThan(String value) {
            addCriterion("AUTHENTICATE_FLAG <", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagLessThanOrEqualTo(String value) {
            addCriterion("AUTHENTICATE_FLAG <=", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagLike(String value) {
            addCriterion("AUTHENTICATE_FLAG like", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotLike(String value) {
            addCriterion("AUTHENTICATE_FLAG not like", value, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagIn(List<String> values) {
            addCriterion("AUTHENTICATE_FLAG in", values, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotIn(List<String> values) {
            addCriterion("AUTHENTICATE_FLAG not in", values, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagBetween(String value1, String value2) {
            addCriterion("AUTHENTICATE_FLAG between", value1, value2, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andAuthenticateFlagNotBetween(String value1, String value2) {
            addCriterion("AUTHENTICATE_FLAG not between", value1, value2, "authenticateFlag");
            return (Criteria) this;
        }

        public Criteria andTradingMethodIsNull() {
            addCriterion("TRADING_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andTradingMethodIsNotNull() {
            addCriterion("TRADING_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andTradingMethodEqualTo(String value) {
            addCriterion("TRADING_METHOD =", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodNotEqualTo(String value) {
            addCriterion("TRADING_METHOD <>", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodGreaterThan(String value) {
            addCriterion("TRADING_METHOD >", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodGreaterThanOrEqualTo(String value) {
            addCriterion("TRADING_METHOD >=", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodLessThan(String value) {
            addCriterion("TRADING_METHOD <", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodLessThanOrEqualTo(String value) {
            addCriterion("TRADING_METHOD <=", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodLike(String value) {
            addCriterion("TRADING_METHOD like", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodNotLike(String value) {
            addCriterion("TRADING_METHOD not like", value, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodIn(List<String> values) {
            addCriterion("TRADING_METHOD in", values, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodNotIn(List<String> values) {
            addCriterion("TRADING_METHOD not in", values, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodBetween(String value1, String value2) {
            addCriterion("TRADING_METHOD between", value1, value2, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andTradingMethodNotBetween(String value1, String value2) {
            addCriterion("TRADING_METHOD not between", value1, value2, "tradingMethod");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordIsNull() {
            addCriterion("LOGIN_PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordIsNotNull() {
            addCriterion("LOGIN_PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordEqualTo(String value) {
            addCriterion("LOGIN_PASSWORD =", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordNotEqualTo(String value) {
            addCriterion("LOGIN_PASSWORD <>", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordGreaterThan(String value) {
            addCriterion("LOGIN_PASSWORD >", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("LOGIN_PASSWORD >=", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordLessThan(String value) {
            addCriterion("LOGIN_PASSWORD <", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordLessThanOrEqualTo(String value) {
            addCriterion("LOGIN_PASSWORD <=", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordLike(String value) {
            addCriterion("LOGIN_PASSWORD like", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordNotLike(String value) {
            addCriterion("LOGIN_PASSWORD not like", value, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordIn(List<String> values) {
            addCriterion("LOGIN_PASSWORD in", values, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordNotIn(List<String> values) {
            addCriterion("LOGIN_PASSWORD not in", values, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordBetween(String value1, String value2) {
            addCriterion("LOGIN_PASSWORD between", value1, value2, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andLoginPasswordNotBetween(String value1, String value2) {
            addCriterion("LOGIN_PASSWORD not between", value1, value2, "loginPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordIsNull() {
            addCriterion("TRANS_PASSWORD is null");
            return (Criteria) this;
        }

        public Criteria andTransPasswordIsNotNull() {
            addCriterion("TRANS_PASSWORD is not null");
            return (Criteria) this;
        }

        public Criteria andTransPasswordEqualTo(String value) {
            addCriterion("TRANS_PASSWORD =", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotEqualTo(String value) {
            addCriterion("TRANS_PASSWORD <>", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordGreaterThan(String value) {
            addCriterion("TRANS_PASSWORD >", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordGreaterThanOrEqualTo(String value) {
            addCriterion("TRANS_PASSWORD >=", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordLessThan(String value) {
            addCriterion("TRANS_PASSWORD <", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordLessThanOrEqualTo(String value) {
            addCriterion("TRANS_PASSWORD <=", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordLike(String value) {
            addCriterion("TRANS_PASSWORD like", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotLike(String value) {
            addCriterion("TRANS_PASSWORD not like", value, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordIn(List<String> values) {
            addCriterion("TRANS_PASSWORD in", values, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotIn(List<String> values) {
            addCriterion("TRANS_PASSWORD not in", values, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordBetween(String value1, String value2) {
            addCriterion("TRANS_PASSWORD between", value1, value2, "transPassword");
            return (Criteria) this;
        }

        public Criteria andTransPasswordNotBetween(String value1, String value2) {
            addCriterion("TRANS_PASSWORD not between", value1, value2, "transPassword");
            return (Criteria) this;
        }

        public Criteria andOperOrgIsNull() {
            addCriterion("OPER_ORG is null");
            return (Criteria) this;
        }

        public Criteria andOperOrgIsNotNull() {
            addCriterion("OPER_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andOperOrgEqualTo(String value) {
            addCriterion("OPER_ORG =", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotEqualTo(String value) {
            addCriterion("OPER_ORG <>", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgGreaterThan(String value) {
            addCriterion("OPER_ORG >", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgGreaterThanOrEqualTo(String value) {
            addCriterion("OPER_ORG >=", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgLessThan(String value) {
            addCriterion("OPER_ORG <", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgLessThanOrEqualTo(String value) {
            addCriterion("OPER_ORG <=", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgLike(String value) {
            addCriterion("OPER_ORG like", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotLike(String value) {
            addCriterion("OPER_ORG not like", value, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgIn(List<String> values) {
            addCriterion("OPER_ORG in", values, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotIn(List<String> values) {
            addCriterion("OPER_ORG not in", values, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgBetween(String value1, String value2) {
            addCriterion("OPER_ORG between", value1, value2, "operOrg");
            return (Criteria) this;
        }

        public Criteria andOperOrgNotBetween(String value1, String value2) {
            addCriterion("OPER_ORG not between", value1, value2, "operOrg");
            return (Criteria) this;
        }

        public Criteria andTaNoIsNull() {
            addCriterion("TA_NO is null");
            return (Criteria) this;
        }

        public Criteria andTaNoIsNotNull() {
            addCriterion("TA_NO is not null");
            return (Criteria) this;
        }

        public Criteria andTaNoEqualTo(String value) {
            addCriterion("TA_NO =", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoNotEqualTo(String value) {
            addCriterion("TA_NO <>", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoGreaterThan(String value) {
            addCriterion("TA_NO >", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoGreaterThanOrEqualTo(String value) {
            addCriterion("TA_NO >=", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoLessThan(String value) {
            addCriterion("TA_NO <", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoLessThanOrEqualTo(String value) {
            addCriterion("TA_NO <=", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoLike(String value) {
            addCriterion("TA_NO like", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoNotLike(String value) {
            addCriterion("TA_NO not like", value, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoIn(List<String> values) {
            addCriterion("TA_NO in", values, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoNotIn(List<String> values) {
            addCriterion("TA_NO not in", values, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoBetween(String value1, String value2) {
            addCriterion("TA_NO between", value1, value2, "taNo");
            return (Criteria) this;
        }

        public Criteria andTaNoNotBetween(String value1, String value2) {
            addCriterion("TA_NO not between", value1, value2, "taNo");
            return (Criteria) this;
        }

        public Criteria andCustRiskIsNull() {
            addCriterion("CUST_RISK is null");
            return (Criteria) this;
        }

        public Criteria andCustRiskIsNotNull() {
            addCriterion("CUST_RISK is not null");
            return (Criteria) this;
        }

        public Criteria andCustRiskEqualTo(String value) {
            addCriterion("CUST_RISK =", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskNotEqualTo(String value) {
            addCriterion("CUST_RISK <>", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskGreaterThan(String value) {
            addCriterion("CUST_RISK >", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskGreaterThanOrEqualTo(String value) {
            addCriterion("CUST_RISK >=", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskLessThan(String value) {
            addCriterion("CUST_RISK <", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskLessThanOrEqualTo(String value) {
            addCriterion("CUST_RISK <=", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskLike(String value) {
            addCriterion("CUST_RISK like", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskNotLike(String value) {
            addCriterion("CUST_RISK not like", value, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskIn(List<String> values) {
            addCriterion("CUST_RISK in", values, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskNotIn(List<String> values) {
            addCriterion("CUST_RISK not in", values, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskBetween(String value1, String value2) {
            addCriterion("CUST_RISK between", value1, value2, "custRisk");
            return (Criteria) this;
        }

        public Criteria andCustRiskNotBetween(String value1, String value2) {
            addCriterion("CUST_RISK not between", value1, value2, "custRisk");
            return (Criteria) this;
        }

        public Criteria andChannelNameIsNull() {
            addCriterion("CHANNEL_NAME is null");
            return (Criteria) this;
        }

        public Criteria andChannelNameIsNotNull() {
            addCriterion("CHANNEL_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andChannelNameEqualTo(String value) {
            addCriterion("CHANNEL_NAME =", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotEqualTo(String value) {
            addCriterion("CHANNEL_NAME <>", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameGreaterThan(String value) {
            addCriterion("CHANNEL_NAME >", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL_NAME >=", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameLessThan(String value) {
            addCriterion("CHANNEL_NAME <", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL_NAME <=", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameLike(String value) {
            addCriterion("CHANNEL_NAME like", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotLike(String value) {
            addCriterion("CHANNEL_NAME not like", value, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameIn(List<String> values) {
            addCriterion("CHANNEL_NAME in", values, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotIn(List<String> values) {
            addCriterion("CHANNEL_NAME not in", values, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameBetween(String value1, String value2) {
            addCriterion("CHANNEL_NAME between", value1, value2, "channelName");
            return (Criteria) this;
        }

        public Criteria andChannelNameNotBetween(String value1, String value2) {
            addCriterion("CHANNEL_NAME not between", value1, value2, "channelName");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoIsNull() {
            addCriterion("HOME_TEL_NO is null");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoIsNotNull() {
            addCriterion("HOME_TEL_NO is not null");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoEqualTo(String value) {
            addCriterion("HOME_TEL_NO =", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoNotEqualTo(String value) {
            addCriterion("HOME_TEL_NO <>", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoGreaterThan(String value) {
            addCriterion("HOME_TEL_NO >", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoGreaterThanOrEqualTo(String value) {
            addCriterion("HOME_TEL_NO >=", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoLessThan(String value) {
            addCriterion("HOME_TEL_NO <", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoLessThanOrEqualTo(String value) {
            addCriterion("HOME_TEL_NO <=", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoLike(String value) {
            addCriterion("HOME_TEL_NO like", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoNotLike(String value) {
            addCriterion("HOME_TEL_NO not like", value, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoIn(List<String> values) {
            addCriterion("HOME_TEL_NO in", values, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoNotIn(List<String> values) {
            addCriterion("HOME_TEL_NO not in", values, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoBetween(String value1, String value2) {
            addCriterion("HOME_TEL_NO between", value1, value2, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andHomeTelNoNotBetween(String value1, String value2) {
            addCriterion("HOME_TEL_NO not between", value1, value2, "homeTelNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeIsNull() {
            addCriterion("TRANSACTOR_CERT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeIsNotNull() {
            addCriterion("TRANSACTOR_CERT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE =", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeNotEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE <>", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeGreaterThan(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE >", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE >=", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeLessThan(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE <", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE <=", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeLike(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE like", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeNotLike(String value) {
            addCriterion("TRANSACTOR_CERT_TYPE not like", value, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeIn(List<String> values) {
            addCriterion("TRANSACTOR_CERT_TYPE in", values, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeNotIn(List<String> values) {
            addCriterion("TRANSACTOR_CERT_TYPE not in", values, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_CERT_TYPE between", value1, value2, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertTypeNotBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_CERT_TYPE not between", value1, value2, "transactorCertType");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoIsNull() {
            addCriterion("TRANSACTOR_CERT_NO is null");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoIsNotNull() {
            addCriterion("TRANSACTOR_CERT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_NO =", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoNotEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_NO <>", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoGreaterThan(String value) {
            addCriterion("TRANSACTOR_CERT_NO >", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_NO >=", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoLessThan(String value) {
            addCriterion("TRANSACTOR_CERT_NO <", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_CERT_NO <=", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoLike(String value) {
            addCriterion("TRANSACTOR_CERT_NO like", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoNotLike(String value) {
            addCriterion("TRANSACTOR_CERT_NO not like", value, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoIn(List<String> values) {
            addCriterion("TRANSACTOR_CERT_NO in", values, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoNotIn(List<String> values) {
            addCriterion("TRANSACTOR_CERT_NO not in", values, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_CERT_NO between", value1, value2, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorCertNoNotBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_CERT_NO not between", value1, value2, "transactorCertNo");
            return (Criteria) this;
        }

        public Criteria andTransactorNameIsNull() {
            addCriterion("TRANSACTOR_NAME is null");
            return (Criteria) this;
        }

        public Criteria andTransactorNameIsNotNull() {
            addCriterion("TRANSACTOR_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andTransactorNameEqualTo(String value) {
            addCriterion("TRANSACTOR_NAME =", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameNotEqualTo(String value) {
            addCriterion("TRANSACTOR_NAME <>", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameGreaterThan(String value) {
            addCriterion("TRANSACTOR_NAME >", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_NAME >=", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameLessThan(String value) {
            addCriterion("TRANSACTOR_NAME <", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_NAME <=", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameLike(String value) {
            addCriterion("TRANSACTOR_NAME like", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameNotLike(String value) {
            addCriterion("TRANSACTOR_NAME not like", value, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameIn(List<String> values) {
            addCriterion("TRANSACTOR_NAME in", values, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameNotIn(List<String> values) {
            addCriterion("TRANSACTOR_NAME not in", values, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_NAME between", value1, value2, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorNameNotBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_NAME not between", value1, value2, "transactorName");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateIsNull() {
            addCriterion("TRANSACTOR_VALIDATE is null");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateIsNotNull() {
            addCriterion("TRANSACTOR_VALIDATE is not null");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateEqualTo(String value) {
            addCriterion("TRANSACTOR_VALIDATE =", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateNotEqualTo(String value) {
            addCriterion("TRANSACTOR_VALIDATE <>", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateGreaterThan(String value) {
            addCriterion("TRANSACTOR_VALIDATE >", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_VALIDATE >=", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateLessThan(String value) {
            addCriterion("TRANSACTOR_VALIDATE <", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_VALIDATE <=", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateLike(String value) {
            addCriterion("TRANSACTOR_VALIDATE like", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateNotLike(String value) {
            addCriterion("TRANSACTOR_VALIDATE not like", value, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateIn(List<String> values) {
            addCriterion("TRANSACTOR_VALIDATE in", values, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateNotIn(List<String> values) {
            addCriterion("TRANSACTOR_VALIDATE not in", values, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_VALIDATE between", value1, value2, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorValidateNotBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_VALIDATE not between", value1, value2, "transactorValidate");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferIsNull() {
            addCriterion("TRANSACTOR__CERT_REFER is null");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferIsNotNull() {
            addCriterion("TRANSACTOR__CERT_REFER is not null");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferEqualTo(String value) {
            addCriterion("TRANSACTOR__CERT_REFER =", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferNotEqualTo(String value) {
            addCriterion("TRANSACTOR__CERT_REFER <>", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferGreaterThan(String value) {
            addCriterion("TRANSACTOR__CERT_REFER >", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR__CERT_REFER >=", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferLessThan(String value) {
            addCriterion("TRANSACTOR__CERT_REFER <", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR__CERT_REFER <=", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferLike(String value) {
            addCriterion("TRANSACTOR__CERT_REFER like", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferNotLike(String value) {
            addCriterion("TRANSACTOR__CERT_REFER not like", value, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferIn(List<String> values) {
            addCriterion("TRANSACTOR__CERT_REFER in", values, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferNotIn(List<String> values) {
            addCriterion("TRANSACTOR__CERT_REFER not in", values, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferBetween(String value1, String value2) {
            addCriterion("TRANSACTOR__CERT_REFER between", value1, value2, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorCertReferNotBetween(String value1, String value2) {
            addCriterion("TRANSACTOR__CERT_REFER not between", value1, value2, "transactorCertRefer");
            return (Criteria) this;
        }

        public Criteria andTransactorTelIsNull() {
            addCriterion("TRANSACTOR_TEL is null");
            return (Criteria) this;
        }

        public Criteria andTransactorTelIsNotNull() {
            addCriterion("TRANSACTOR_TEL is not null");
            return (Criteria) this;
        }

        public Criteria andTransactorTelEqualTo(String value) {
            addCriterion("TRANSACTOR_TEL =", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelNotEqualTo(String value) {
            addCriterion("TRANSACTOR_TEL <>", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelGreaterThan(String value) {
            addCriterion("TRANSACTOR_TEL >", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_TEL >=", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelLessThan(String value) {
            addCriterion("TRANSACTOR_TEL <", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelLessThanOrEqualTo(String value) {
            addCriterion("TRANSACTOR_TEL <=", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelLike(String value) {
            addCriterion("TRANSACTOR_TEL like", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelNotLike(String value) {
            addCriterion("TRANSACTOR_TEL not like", value, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelIn(List<String> values) {
            addCriterion("TRANSACTOR_TEL in", values, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelNotIn(List<String> values) {
            addCriterion("TRANSACTOR_TEL not in", values, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_TEL between", value1, value2, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andTransactorTelNotBetween(String value1, String value2) {
            addCriterion("TRANSACTOR_TEL not between", value1, value2, "transactorTel");
            return (Criteria) this;
        }

        public Criteria andCheckInfoIsNull() {
            addCriterion("CHECK_INFO is null");
            return (Criteria) this;
        }

        public Criteria andCheckInfoIsNotNull() {
            addCriterion("CHECK_INFO is not null");
            return (Criteria) this;
        }

        public Criteria andCheckInfoEqualTo(String value) {
            addCriterion("CHECK_INFO =", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoNotEqualTo(String value) {
            addCriterion("CHECK_INFO <>", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoGreaterThan(String value) {
            addCriterion("CHECK_INFO >", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoGreaterThanOrEqualTo(String value) {
            addCriterion("CHECK_INFO >=", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoLessThan(String value) {
            addCriterion("CHECK_INFO <", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoLessThanOrEqualTo(String value) {
            addCriterion("CHECK_INFO <=", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoLike(String value) {
            addCriterion("CHECK_INFO like", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoNotLike(String value) {
            addCriterion("CHECK_INFO not like", value, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoIn(List<String> values) {
            addCriterion("CHECK_INFO in", values, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoNotIn(List<String> values) {
            addCriterion("CHECK_INFO not in", values, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoBetween(String value1, String value2) {
            addCriterion("CHECK_INFO between", value1, value2, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andCheckInfoNotBetween(String value1, String value2) {
            addCriterion("CHECK_INFO not between", value1, value2, "checkInfo");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("SOURCE is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("SOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(String value) {
            addCriterion("SOURCE =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(String value) {
            addCriterion("SOURCE <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(String value) {
            addCriterion("SOURCE >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(String value) {
            addCriterion("SOURCE >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(String value) {
            addCriterion("SOURCE <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(String value) {
            addCriterion("SOURCE <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLike(String value) {
            addCriterion("SOURCE like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotLike(String value) {
            addCriterion("SOURCE not like", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<String> values) {
            addCriterion("SOURCE in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<String> values) {
            addCriterion("SOURCE not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(String value1, String value2) {
            addCriterion("SOURCE between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(String value1, String value2) {
            addCriterion("SOURCE not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceKeyIsNull() {
            addCriterion("SOURCE_KEY is null");
            return (Criteria) this;
        }

        public Criteria andSourceKeyIsNotNull() {
            addCriterion("SOURCE_KEY is not null");
            return (Criteria) this;
        }

        public Criteria andSourceKeyEqualTo(String value) {
            addCriterion("SOURCE_KEY =", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyNotEqualTo(String value) {
            addCriterion("SOURCE_KEY <>", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyGreaterThan(String value) {
            addCriterion("SOURCE_KEY >", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyGreaterThanOrEqualTo(String value) {
            addCriterion("SOURCE_KEY >=", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyLessThan(String value) {
            addCriterion("SOURCE_KEY <", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyLessThanOrEqualTo(String value) {
            addCriterion("SOURCE_KEY <=", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyLike(String value) {
            addCriterion("SOURCE_KEY like", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyNotLike(String value) {
            addCriterion("SOURCE_KEY not like", value, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyIn(List<String> values) {
            addCriterion("SOURCE_KEY in", values, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyNotIn(List<String> values) {
            addCriterion("SOURCE_KEY not in", values, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyBetween(String value1, String value2) {
            addCriterion("SOURCE_KEY between", value1, value2, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andSourceKeyNotBetween(String value1, String value2) {
            addCriterion("SOURCE_KEY not between", value1, value2, "sourceKey");
            return (Criteria) this;
        }

        public Criteria andTradeCauseIsNull() {
            addCriterion("TRADE_CAUSE is null");
            return (Criteria) this;
        }

        public Criteria andTradeCauseIsNotNull() {
            addCriterion("TRADE_CAUSE is not null");
            return (Criteria) this;
        }

        public Criteria andTradeCauseEqualTo(String value) {
            addCriterion("TRADE_CAUSE =", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseNotEqualTo(String value) {
            addCriterion("TRADE_CAUSE <>", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseGreaterThan(String value) {
            addCriterion("TRADE_CAUSE >", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseGreaterThanOrEqualTo(String value) {
            addCriterion("TRADE_CAUSE >=", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseLessThan(String value) {
            addCriterion("TRADE_CAUSE <", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseLessThanOrEqualTo(String value) {
            addCriterion("TRADE_CAUSE <=", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseLike(String value) {
            addCriterion("TRADE_CAUSE like", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseNotLike(String value) {
            addCriterion("TRADE_CAUSE not like", value, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseIn(List<String> values) {
            addCriterion("TRADE_CAUSE in", values, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseNotIn(List<String> values) {
            addCriterion("TRADE_CAUSE not in", values, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseBetween(String value1, String value2) {
            addCriterion("TRADE_CAUSE between", value1, value2, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andTradeCauseNotBetween(String value1, String value2) {
            addCriterion("TRADE_CAUSE not between", value1, value2, "tradeCause");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameIsNull() {
            addCriterion("ACTUAL_CTRL_NAME is null");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameIsNotNull() {
            addCriterion("ACTUAL_CTRL_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameEqualTo(String value) {
            addCriterion("ACTUAL_CTRL_NAME =", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameNotEqualTo(String value) {
            addCriterion("ACTUAL_CTRL_NAME <>", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameGreaterThan(String value) {
            addCriterion("ACTUAL_CTRL_NAME >", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameGreaterThanOrEqualTo(String value) {
            addCriterion("ACTUAL_CTRL_NAME >=", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameLessThan(String value) {
            addCriterion("ACTUAL_CTRL_NAME <", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameLessThanOrEqualTo(String value) {
            addCriterion("ACTUAL_CTRL_NAME <=", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameLike(String value) {
            addCriterion("ACTUAL_CTRL_NAME like", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameNotLike(String value) {
            addCriterion("ACTUAL_CTRL_NAME not like", value, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameIn(List<String> values) {
            addCriterion("ACTUAL_CTRL_NAME in", values, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameNotIn(List<String> values) {
            addCriterion("ACTUAL_CTRL_NAME not in", values, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameBetween(String value1, String value2) {
            addCriterion("ACTUAL_CTRL_NAME between", value1, value2, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andActualCtrlNameNotBetween(String value1, String value2) {
            addCriterion("ACTUAL_CTRL_NAME not between", value1, value2, "actualCtrlName");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryIsNull() {
            addCriterion("BENEFICIARY is null");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryIsNotNull() {
            addCriterion("BENEFICIARY is not null");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryEqualTo(String value) {
            addCriterion("BENEFICIARY =", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryNotEqualTo(String value) {
            addCriterion("BENEFICIARY <>", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryGreaterThan(String value) {
            addCriterion("BENEFICIARY >", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryGreaterThanOrEqualTo(String value) {
            addCriterion("BENEFICIARY >=", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryLessThan(String value) {
            addCriterion("BENEFICIARY <", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryLessThanOrEqualTo(String value) {
            addCriterion("BENEFICIARY <=", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryLike(String value) {
            addCriterion("BENEFICIARY like", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryNotLike(String value) {
            addCriterion("BENEFICIARY not like", value, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryIn(List<String> values) {
            addCriterion("BENEFICIARY in", values, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryNotIn(List<String> values) {
            addCriterion("BENEFICIARY not in", values, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryBetween(String value1, String value2) {
            addCriterion("BENEFICIARY between", value1, value2, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andBeneficiaryNotBetween(String value1, String value2) {
            addCriterion("BENEFICIARY not between", value1, value2, "beneficiary");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNull() {
            addCriterion("CONTRACT_NO is null");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNotNull() {
            addCriterion("CONTRACT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andContractNoEqualTo(String value) {
            addCriterion("CONTRACT_NO =", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotEqualTo(String value) {
            addCriterion("CONTRACT_NO <>", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThan(String value) {
            addCriterion("CONTRACT_NO >", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO >=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThan(String value) {
            addCriterion("CONTRACT_NO <", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO <=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLike(String value) {
            addCriterion("CONTRACT_NO like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotLike(String value) {
            addCriterion("CONTRACT_NO not like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIn(List<String> values) {
            addCriterion("CONTRACT_NO in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotIn(List<String> values) {
            addCriterion("CONTRACT_NO not in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO not between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andAcountTypeIsNull() {
            addCriterion("ACOUNT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andAcountTypeIsNotNull() {
            addCriterion("ACOUNT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andAcountTypeEqualTo(String value) {
            addCriterion("ACOUNT_TYPE =", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotEqualTo(String value) {
            addCriterion("ACOUNT_TYPE <>", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeGreaterThan(String value) {
            addCriterion("ACOUNT_TYPE >", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeGreaterThanOrEqualTo(String value) {
            addCriterion("ACOUNT_TYPE >=", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeLessThan(String value) {
            addCriterion("ACOUNT_TYPE <", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeLessThanOrEqualTo(String value) {
            addCriterion("ACOUNT_TYPE <=", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeLike(String value) {
            addCriterion("ACOUNT_TYPE like", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotLike(String value) {
            addCriterion("ACOUNT_TYPE not like", value, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeIn(List<String> values) {
            addCriterion("ACOUNT_TYPE in", values, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotIn(List<String> values) {
            addCriterion("ACOUNT_TYPE not in", values, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeBetween(String value1, String value2) {
            addCriterion("ACOUNT_TYPE between", value1, value2, "acountType");
            return (Criteria) this;
        }

        public Criteria andAcountTypeNotBetween(String value1, String value2) {
            addCriterion("ACOUNT_TYPE not between", value1, value2, "acountType");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameIsNull() {
            addCriterion("BANK_BRANCH_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameIsNotNull() {
            addCriterion("BANK_BRANCH_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME =", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME <>", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameGreaterThan(String value) {
            addCriterion("BANK_BRANCH_NAME >", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME >=", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameLessThan(String value) {
            addCriterion("BANK_BRANCH_NAME <", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameLessThanOrEqualTo(String value) {
            addCriterion("BANK_BRANCH_NAME <=", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameLike(String value) {
            addCriterion("BANK_BRANCH_NAME like", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotLike(String value) {
            addCriterion("BANK_BRANCH_NAME not like", value, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameIn(List<String> values) {
            addCriterion("BANK_BRANCH_NAME in", values, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotIn(List<String> values) {
            addCriterion("BANK_BRANCH_NAME not in", values, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameBetween(String value1, String value2) {
            addCriterion("BANK_BRANCH_NAME between", value1, value2, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andBankBranchNameNotBetween(String value1, String value2) {
            addCriterion("BANK_BRANCH_NAME not between", value1, value2, "bankBranchName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameIsNull() {
            addCriterion("OTHER_BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameIsNotNull() {
            addCriterion("OTHER_BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME =", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME <>", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameGreaterThan(String value) {
            addCriterion("OTHER_BANK_NAME >", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME >=", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameLessThan(String value) {
            addCriterion("OTHER_BANK_NAME <", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameLessThanOrEqualTo(String value) {
            addCriterion("OTHER_BANK_NAME <=", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameLike(String value) {
            addCriterion("OTHER_BANK_NAME like", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotLike(String value) {
            addCriterion("OTHER_BANK_NAME not like", value, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameIn(List<String> values) {
            addCriterion("OTHER_BANK_NAME in", values, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotIn(List<String> values) {
            addCriterion("OTHER_BANK_NAME not in", values, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameBetween(String value1, String value2) {
            addCriterion("OTHER_BANK_NAME between", value1, value2, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andOtherBankNameNotBetween(String value1, String value2) {
            addCriterion("OTHER_BANK_NAME not between", value1, value2, "otherBankName");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignIsNull() {
            addCriterion("MOBILE_AUTH_SIGN is null");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignIsNotNull() {
            addCriterion("MOBILE_AUTH_SIGN is not null");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignEqualTo(String value) {
            addCriterion("MOBILE_AUTH_SIGN =", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignNotEqualTo(String value) {
            addCriterion("MOBILE_AUTH_SIGN <>", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignGreaterThan(String value) {
            addCriterion("MOBILE_AUTH_SIGN >", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignGreaterThanOrEqualTo(String value) {
            addCriterion("MOBILE_AUTH_SIGN >=", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignLessThan(String value) {
            addCriterion("MOBILE_AUTH_SIGN <", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignLessThanOrEqualTo(String value) {
            addCriterion("MOBILE_AUTH_SIGN <=", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignLike(String value) {
            addCriterion("MOBILE_AUTH_SIGN like", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignNotLike(String value) {
            addCriterion("MOBILE_AUTH_SIGN not like", value, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignIn(List<String> values) {
            addCriterion("MOBILE_AUTH_SIGN in", values, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignNotIn(List<String> values) {
            addCriterion("MOBILE_AUTH_SIGN not in", values, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignBetween(String value1, String value2) {
            addCriterion("MOBILE_AUTH_SIGN between", value1, value2, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andMobileAuthSignNotBetween(String value1, String value2) {
            addCriterion("MOBILE_AUTH_SIGN not between", value1, value2, "mobileAuthSign");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagIsNull() {
            addCriterion("DXFROM_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagIsNotNull() {
            addCriterion("DXFROM_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagEqualTo(String value) {
            addCriterion("DXFROM_FLAG =", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagNotEqualTo(String value) {
            addCriterion("DXFROM_FLAG <>", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagGreaterThan(String value) {
            addCriterion("DXFROM_FLAG >", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagGreaterThanOrEqualTo(String value) {
            addCriterion("DXFROM_FLAG >=", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagLessThan(String value) {
            addCriterion("DXFROM_FLAG <", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagLessThanOrEqualTo(String value) {
            addCriterion("DXFROM_FLAG <=", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagLike(String value) {
            addCriterion("DXFROM_FLAG like", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagNotLike(String value) {
            addCriterion("DXFROM_FLAG not like", value, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagIn(List<String> values) {
            addCriterion("DXFROM_FLAG in", values, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagNotIn(List<String> values) {
            addCriterion("DXFROM_FLAG not in", values, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagBetween(String value1, String value2) {
            addCriterion("DXFROM_FLAG between", value1, value2, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andDxfromFlagNotBetween(String value1, String value2) {
            addCriterion("DXFROM_FLAG not between", value1, value2, "dxfromFlag");
            return (Criteria) this;
        }

        public Criteria andAdsourceIsNull() {
            addCriterion("ADSOURCE is null");
            return (Criteria) this;
        }

        public Criteria andAdsourceIsNotNull() {
            addCriterion("ADSOURCE is not null");
            return (Criteria) this;
        }

        public Criteria andAdsourceEqualTo(String value) {
            addCriterion("ADSOURCE =", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotEqualTo(String value) {
            addCriterion("ADSOURCE <>", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceGreaterThan(String value) {
            addCriterion("ADSOURCE >", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceGreaterThanOrEqualTo(String value) {
            addCriterion("ADSOURCE >=", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceLessThan(String value) {
            addCriterion("ADSOURCE <", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceLessThanOrEqualTo(String value) {
            addCriterion("ADSOURCE <=", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceLike(String value) {
            addCriterion("ADSOURCE like", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotLike(String value) {
            addCriterion("ADSOURCE not like", value, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceIn(List<String> values) {
            addCriterion("ADSOURCE in", values, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotIn(List<String> values) {
            addCriterion("ADSOURCE not in", values, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceBetween(String value1, String value2) {
            addCriterion("ADSOURCE between", value1, value2, "adsource");
            return (Criteria) this;
        }

        public Criteria andAdsourceNotBetween(String value1, String value2) {
            addCriterion("ADSOURCE not between", value1, value2, "adsource");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExIsNull() {
            addCriterion("APP_SHEET_SERIALNO_EX is null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExIsNotNull() {
            addCriterion("APP_SHEET_SERIALNO_EX is not null");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX =", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX <>", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExGreaterThan(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX >", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExGreaterThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX >=", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExLessThan(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX <", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExLessThanOrEqualTo(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX <=", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExLike(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX like", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotLike(String value) {
            addCriterion("APP_SHEET_SERIALNO_EX not like", value, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExIn(List<String> values) {
            addCriterion("APP_SHEET_SERIALNO_EX in", values, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotIn(List<String> values) {
            addCriterion("APP_SHEET_SERIALNO_EX not in", values, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIALNO_EX between", value1, value2, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andAppSheetSerialnoExNotBetween(String value1, String value2) {
            addCriterion("APP_SHEET_SERIALNO_EX not between", value1, value2, "appSheetSerialnoEx");
            return (Criteria) this;
        }

        public Criteria andCreatedTsIsNull() {
            addCriterion("CREATED_TS is null");
            return (Criteria) this;
        }

        public Criteria andCreatedTsIsNotNull() {
            addCriterion("CREATED_TS is not null");
            return (Criteria) this;
        }

        public Criteria andCreatedTsEqualTo(Date value) {
            addCriterion("CREATED_TS =", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsNotEqualTo(Date value) {
            addCriterion("CREATED_TS <>", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsGreaterThan(Date value) {
            addCriterion("CREATED_TS >", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATED_TS >=", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsLessThan(Date value) {
            addCriterion("CREATED_TS <", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsLessThanOrEqualTo(Date value) {
            addCriterion("CREATED_TS <=", value, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsIn(List<Date> values) {
            addCriterion("CREATED_TS in", values, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsNotIn(List<Date> values) {
            addCriterion("CREATED_TS not in", values, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsBetween(Date value1, Date value2) {
            addCriterion("CREATED_TS between", value1, value2, "createdTs");
            return (Criteria) this;
        }

        public Criteria andCreatedTsNotBetween(Date value1, Date value2) {
            addCriterion("CREATED_TS not between", value1, value2, "createdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsIsNull() {
            addCriterion("LAST_UPD_TS is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsIsNotNull() {
            addCriterion("LAST_UPD_TS is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsEqualTo(Date value) {
            addCriterion("LAST_UPD_TS =", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsNotEqualTo(Date value) {
            addCriterion("LAST_UPD_TS <>", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsGreaterThan(Date value) {
            addCriterion("LAST_UPD_TS >", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsGreaterThanOrEqualTo(Date value) {
            addCriterion("LAST_UPD_TS >=", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsLessThan(Date value) {
            addCriterion("LAST_UPD_TS <", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsLessThanOrEqualTo(Date value) {
            addCriterion("LAST_UPD_TS <=", value, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsIn(List<Date> values) {
            addCriterion("LAST_UPD_TS in", values, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsNotIn(List<Date> values) {
            addCriterion("LAST_UPD_TS not in", values, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsBetween(Date value1, Date value2) {
            addCriterion("LAST_UPD_TS between", value1, value2, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andLastUpdTsNotBetween(Date value1, Date value2) {
            addCriterion("LAST_UPD_TS not between", value1, value2, "lastUpdTs");
            return (Criteria) this;
        }

        public Criteria andFailureReasonIsNull() {
            addCriterion("FAILURE_REASON is null");
            return (Criteria) this;
        }

        public Criteria andFailureReasonIsNotNull() {
            addCriterion("FAILURE_REASON is not null");
            return (Criteria) this;
        }

        public Criteria andFailureReasonEqualTo(String value) {
            addCriterion("FAILURE_REASON =", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonNotEqualTo(String value) {
            addCriterion("FAILURE_REASON <>", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonGreaterThan(String value) {
            addCriterion("FAILURE_REASON >", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonGreaterThanOrEqualTo(String value) {
            addCriterion("FAILURE_REASON >=", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonLessThan(String value) {
            addCriterion("FAILURE_REASON <", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonLessThanOrEqualTo(String value) {
            addCriterion("FAILURE_REASON <=", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonLike(String value) {
            addCriterion("FAILURE_REASON like", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonNotLike(String value) {
            addCriterion("FAILURE_REASON not like", value, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonIn(List<String> values) {
            addCriterion("FAILURE_REASON in", values, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonNotIn(List<String> values) {
            addCriterion("FAILURE_REASON not in", values, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonBetween(String value1, String value2) {
            addCriterion("FAILURE_REASON between", value1, value2, "failureReason");
            return (Criteria) this;
        }

        public Criteria andFailureReasonNotBetween(String value1, String value2) {
            addCriterion("FAILURE_REASON not between", value1, value2, "failureReason");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("BANK_NAME =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("BANK_NAME <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("BANK_NAME >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_NAME >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("BANK_NAME <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("BANK_NAME <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("BANK_NAME like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("BANK_NAME not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("BANK_NAME in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("BANK_NAME not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("BANK_NAME between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("BANK_NAME not between", value1, value2, "bankName");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}